Diagram Cost_Split

Defincja diagramu Cost_Split

Name

Cost_Split

Code

Cost_Split

Comment

 


Lista tabel diagramu

Name

Code

AccountGroup

AccountGroup

Accounts

Accounts

CostType

CostType

GradeGroup

GradeGroup

GradeGroupCost

GradeGroupCost

Import

Import

ImportParam

ImportParam

Income

Income

Keys

Keys

LOrgUnitAccount

LOrgUnitAccount

LResourceItemAccount

LResourceItemAccount

Period

Period

PeriodInfo

PeriodInfo

PeriodType

PeriodType

Personnel

Personnel

repDefSQL

repDefSQL

ResourceItem

ResourceItem

ResourceType

ResourceType

Service

Service

ServiceComponent

ServiceComponent

ServiceComponentMap

ServiceComponentMap

ServiceRealCost

ServiceRealCost

SplitDirectResult

SplitDirectResult

SplitIndirectResult

SplitIndirectResult

SplitResult

SplitResult

SplitResultSum

SplitResultSum

Step

Step


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_29

R_29

Step

Keys

StepID

 

 

R_55

R_55

Step

SplitResult

StepID

 

 

R_62

R_62

Accounts

Import

AccountID

 

 

R_72

R_72

Accounts

SplitResult

AccountID

 

 

R_129

R_129

CostType

Keys

CostTypeID

 

 

R_130

R_130

CostType

SplitResult

CostTypeID

 

 

R_131

R_131

CostType

SplitResultSum

CostTypeID

 

 

R_132

R_132

Period

SplitResultSum

PeriodID

 

 

R_133

R_133

Period

SplitResult

PeriodID

 

 

R_135

R_135

Period

Import

PeriodID

 

 

R_748

R_748

Step

SplitResultSum

StepID

 

 

R_1082

R_1082

ResourceType

Accounts

ResourceTypeID

 

 

R_1111

R_1111

Period

Keys

PeriodID

 

 

R_1112

R_1112

ResourceType

Keys

ResourceTypeID

 

 

R_1563

R_1563

Accounts

LOrgUnitAccount

AccountID

 

 

R_1599

R_1599

Accounts

Income

AccountID

 

 

R_1600

R_1600

Period

Income

PeriodID

 

 

R_3060

R_3060

AccountGroup

Accounts

AccountGroupID

 

 

R_3061

R_3061

GradeGroup

GradeGroupCost

GradeGroupID

 

 

R_3062

R_3062

GradeGroup

Personnel

GradeGroupID

 

 

R_6080

R_6080

Period

SplitDirectResult

PeriodID

 

 

R_6082

R_6082

Accounts

SplitDirectResult

AccountID

 

 

R_6083

R_6083

Period

SplitIndirectResult

PeriodID

 

 

R_6086

R_6086

Accounts

SplitIndirectResult

AccountID

 

 

R_8290

R_8290

ServiceComponent

ServiceComponentMap

ServiceComponentID

 

 

R_8291

R_8291

ServiceComponent

Service

ServiceComponentID

 

 

R_8292

R_8292

ServiceComponent

ServiceRealCost

ServiceComponentID

 

 

R_8293

R_8293

PeriodType

Period

PeriodTypeID

 

 

R_8294

R_8294

Period

PeriodInfo

PeriodID

 

 

R_9145

R_9145

ResourceItem

LResourceItemAccount

ResourceID

 

 

R_9146

R_9146

Accounts

LResourceItemAccount

AccountID